package com.sea.supply.mapper;

import com.sea.supply.entity.PdfFile;
import com.sea.supply.entity.PdfRead;
import org.apache.ibatis.annotations.Param;

import java.util.List;


/**
 *  待采购接口
 * @author 陈鸿飞
 * <br/>
 */
public interface PdfMapper {

    /**
     * 新增
     * @param pdfRead
     * @return
     */
    int insert(PdfRead pdfRead);

    int update(PdfRead pdfRead);

    List<PdfRead> findBySku(@Param("pdfSku")String pdfSku,@Param("createPlanNo")String createPlanNo,@Param("number")Integer number);

    List<PdfRead> findSupplierName(String createPlanNo);

    List<PdfRead> findBySupplierNameCreatePlanNo(@Param("createPlanNo")String createPlanNo,
                                                 @Param("pdfSupplierName")String pdfSupplierName);

    List<PdfRead> findByPdfPlanNo(PdfFile pdfFile);

    Integer deleteByPdfPlanNo(String pdfPlanNo);

    Integer clearPdfSku();

    /**
     * 获取SKU分组
     * @return
     */
    List<PdfRead> groupBySku();

    List<PdfRead> queryBySku(String pdfSku);


}